import pandas as pd
import numpy as np
a={'人名':{'A':,'B':},
   '数学':{'A':'100','B':'0'},
   '英语':{'A':'100','B':'0'},
   '语文':{'A':'100','B':'0'}}
b=pd.DataFrame(a)
w=pd.ExcelWriter('工作簿2.xlsx')
b.to_excel(w)
w.save()

